Overview

Dataset info

Number of variables181
Number of observations2000
Missing cells240887 (66.5%)
Duplicate rows0 (0.0%)
Total size in memory2.7 MiB
Average record size in memory1.4 KiB

Variables types

Numeric47
Categorical32
Boolean27
Date0
URL0
Text (Unique)1
Rejected74
Unsupported0

Warnings

coligada_mais_antiga_ativa has 1737 (86.9%) missing values Missing
coligada_mais_antiga_baixada has 1999 (> 99.9%) missing values Missing
coligada_mais_nova_ativa has 1737 (86.9%) missing values Missing
coligada_mais_nova_baixada has 1999 (> 99.9%) missing values Missing
de_faixa_faturamento_estimado has 118 (5.9%) missing values Missing
de_faixa_faturamento_estimado_grupo has 118 (5.9%) missing values Missing
de_indicador_telefone has 1804 (90.2%) missing values Missing
de_nivel_atividade has 51 (2.5%) missing values Missing
de_saude_rescencia has 64 (3.2%) missing values Missing
de_saude_tributaria has 64 (3.2%) missing values Missing
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 1315 distinct values Warning
empsetorcensitariofaixarendapopulacao has 600 (30.0%) missing values Missing
faturamento_est_coligados has 1738 (86.9%) missing values Missing
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.9509546939) Rejected
fl_epp has constant value "False" Rejected
fl_optante_simei has 346 (17.3%) missing values Missing
fl_optante_simples has 346 (17.3%) missing values Missing
fl_st_especial has constant value "False" Rejected
grau_instrucao_macro_analfabeto has 1994 (99.7%) missing values Missing
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.9980369909) Rejected
grau_instrucao_macro_escolaridade_media has 1694 (84.7%) missing values Missing
grau_instrucao_macro_escolaridade_superior is highly correlated with grau_instrucao_macro_escolaridade_media (ρ = 0.9178829036) Rejected
idade_acima_de_58 is highly correlated with grau_instrucao_macro_analfabeto (ρ = 1) Rejected
idade_ate_18 has 1990 (99.5%) missing values Missing
idade_de_19_a_23 has 1879 (94.0%) missing values Missing
idade_de_24_a_28 is highly correlated with idade_de_19_a_23 (ρ = 0.9086682511) Rejected
idade_de_29_a_33 is highly correlated with grau_instrucao_macro_escolaridade_superior (ρ = 0.9749169386) Rejected
idade_de_34_a_38 is highly correlated with idade_de_29_a_33 (ρ = 0.994053508) Rejected
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.9834868533) Rejected
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.9491747935) Rejected
idade_de_49_a_53 is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.9891584832) Rejected
idade_de_54_a_58 is highly correlated with idade_de_49_a_53 (ρ = 0.9617506252) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.9997565556) Rejected
idade_maxima_socios has 659 (33.0%) missing values Missing
idade_media_coligadas has 1737 (86.9%) missing values Missing
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.9996384056) Rejected
idade_media_coligadas_baixadas has 1999 (> 99.9%) missing values Missing
idade_media_socios is highly correlated with idade_maxima_socios (ρ = 0.9554366317) Rejected
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 1) Rejected
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.9505781936) Rejected
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados_gp (ρ = 0.9359933557) Rejected
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.9599434338) Rejected
max_filiais_coligados has 1919 (96.0%) missing values Missing
max_funcionarios_coligados_gp has 28 (1.4%) zeros Zeros
max_funcionarios_coligados_gp has 1830 (91.5%) missing values Missing
max_meses_servicos is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.9664890124) Rejected
max_meses_servicos_all is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.9664890124) Rejected
max_vl_folha_coligados has 1858 (92.9%) missing values Missing
max_vl_folha_coligados_gp is highly correlated with max_funcionarios_coligados_gp (ρ = 0.9048394021) Rejected
media_faturamento_est_coligados has 1738 (86.9%) missing values Missing
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.9503777089) Rejected
media_filiais_coligados has 1919 (96.0%) missing values Missing
media_funcionarios_coligados_gp has 28 (1.4%) zeros Zeros
media_funcionarios_coligados_gp has 1830 (91.5%) missing values Missing
media_meses_servicos is highly correlated with max_meses_servicos (ρ = 0.9868452786) Rejected
media_meses_servicos_all is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.9765604493) Rejected
media_vl_folha_coligados has 1858 (92.9%) missing values Missing
media_vl_folha_coligados_gp is highly correlated with media_funcionarios_coligados_gp (ρ = 0.9041231022) Rejected
meses_ultima_contratacaco has 1533 (76.6%) missing values Missing
min_faturamento_est_coligados has 1738 (86.9%) missing values Missing
min_faturamento_est_coligados_gp has 1738 (86.9%) missing values Missing
min_filiais_coligados is highly correlated with min_faturamento_est_coligados_gp (ρ = 0.942216953) Rejected
min_funcionarios_coligados_gp is highly correlated with min_filiais_coligados (ρ = 0.9051143156) Rejected
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.9357049853) Rejected
min_meses_servicos_all is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.9830648574) Rejected
min_vl_folha_coligados has 1858 (92.9%) missing values Missing
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.9817628137) Rejected
nm_divisao has a high cardinality: 72 distinct values Warning
nm_meso_regiao has 278 (13.9%) missing values Missing
nm_micro_regiao has a high cardinality: 73 distinct values Warning
nm_micro_regiao has 278 (13.9%) missing values Missing
nu_meses_rescencia has 199 (10.0%) missing values Missing
percent_func_genero_fem is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.9457217032) Rejected
percent_func_genero_masc has 83 (4.2%) zeros Zeros
percent_func_genero_masc has 1659 (83.0%) missing values Missing
qt_admitidos has 1533 (76.6%) missing values Missing
qt_admitidos_12meses has 342 (17.1%) zeros Zeros
qt_admitidos_12meses has 1533 (76.6%) missing values Missing
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art has 1974 (98.7%) missing values Missing
qt_coligadas has 1791 (89.5%) missing values Missing
qt_coligados is highly correlated with qt_coligadas (ρ = 0.9950754524) Rejected
qt_coligados_agropecuaria has 1737 (86.9%) missing values Missing
qt_coligados_atividade_alto has 1737 (86.9%) missing values Missing
qt_coligados_atividade_baixo has 1737 (86.9%) missing values Missing
qt_coligados_atividade_inativo has 1737 (86.9%) missing values Missing
qt_coligados_atividade_medio has 1737 (86.9%) missing values Missing
qt_coligados_atividade_mt_baixo has 1737 (86.9%) missing values Missing
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.9922537325) Rejected
qt_coligados_baixada is highly correlated with min_vl_folha_coligados_gp (ρ = 0.9776137125) Rejected
qt_coligados_ccivil has 212 (10.6%) zeros Zeros
qt_coligados_ccivil has 1737 (86.9%) missing values Missing
qt_coligados_centro has 255 (12.8%) zeros Zeros
qt_coligados_centro has 1737 (86.9%) missing values Missing
qt_coligados_comercio has 144 (7.2%) zeros Zeros
qt_coligados_comercio has 1737 (86.9%) missing values Missing
qt_coligados_epp has 1737 (86.9%) missing values Missing
qt_coligados_exterior has 1737 (86.9%) missing values Missing
qt_coligados_inapta has 1737 (86.9%) missing values Missing
qt_coligados_industria has 229 (11.5%) zeros Zeros
qt_coligados_industria has 1737 (86.9%) missing values Missing
qt_coligados_ltda has 1737 (86.9%) missing values Missing
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.9940913825) Rejected
qt_coligados_me has 1737 (86.9%) missing values Missing
qt_coligados_mei has 1737 (86.9%) missing values Missing
qt_coligados_nordeste has 93 (4.7%) zeros Zeros
qt_coligados_nordeste has 1737 (86.9%) missing values Missing
qt_coligados_norte is highly correlated with idade_ate_18 (ρ = 0.9001915505) Rejected
qt_coligados_nula has 1737 (86.9%) missing values Missing
qt_coligados_sa is highly correlated with qt_coligados_matriz (ρ = 0.9176972372) Rejected
qt_coligados_serviço has 96 (4.8%) zeros Zeros
qt_coligados_serviço has 1737 (86.9%) missing values Missing
qt_coligados_sudeste is highly correlated with qt_coligados_sa (ρ = 0.9150368291) Rejected
qt_coligados_sul has 258 (12.9%) zeros Zeros
qt_coligados_sul has 1737 (86.9%) missing values Missing
qt_coligados_suspensa has 1737 (86.9%) missing values Missing
qt_desligados has 54 (2.7%) zeros Zeros
qt_desligados has 1533 (76.6%) missing values Missing
qt_desligados_12meses has 332 (16.6%) zeros Zeros
qt_desligados_12meses has 1533 (76.6%) missing values Missing
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 0.9999961944) Rejected
qt_filiais is highly skewed (γ1 = 27.83323791) Skewed
qt_filiais has 1818 (90.9%) zeros Zeros
qt_funcionarios is highly correlated with idade_de_44_a_48 (ρ = 0.9521282594) Rejected
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.9870025118) Rejected
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.9812462049) Rejected
qt_funcionarios_coligados is highly correlated with qt_coligados_sudeste (ρ = 0.9073230395) Rejected
qt_funcionarios_coligados_gp is highly correlated with max_funcionarios_coligados_gp (ρ = 0.9739337033) Rejected
qt_funcionarios_grupo is highly correlated with qt_filiais (ρ = 0.9003805679) Rejected
qt_ramos_coligados is highly correlated with qt_coligadas (ρ = 0.9442422997) Rejected
qt_regioes_coligados has 1737 (86.9%) missing values Missing
qt_socios has 502 (25.1%) missing values Missing
qt_socios_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.9113228208) Rejected
qt_socios_feminino has 1377 (68.8%) missing values Missing
qt_socios_masculino has 1139 (57.0%) missing values Missing
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.9867818247) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.9309382851) Rejected
qt_socios_pj has 502 (25.1%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 1) Rejected
qt_socios_pj_baixados has 1981 (99.1%) missing values Missing
qt_socios_pj_inaptos has 1981 (99.1%) missing values Missing
qt_socios_pj_nulos has 1981 (99.1%) missing values Missing
qt_socios_pj_suspensos has 1981 (99.1%) missing values Missing
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.9649092969) Rejected
qt_socios_st_suspensa has 1986 (99.3%) missing values Missing
qt_ufs_coligados has 1737 (86.9%) missing values Missing
sum_faturamento_estimado_coligadas is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.9984290135) Rejected
total is highly correlated with qt_funcionarios_24meses (ρ = 0.9914053461) Rejected
total_filiais_coligados is highly correlated with qt_socios_coligados (ρ = 0.9651560413) Rejected
tx_crescimento_12meses has 210 (10.5%) zeros Zeros
tx_crescimento_12meses has 1658 (82.9%) missing values Missing
tx_crescimento_24meses has 131 (6.6%) zeros Zeros
tx_crescimento_24meses has 1646 (82.3%) missing values Missing
tx_rotatividade has 362 (18.1%) zeros Zeros
tx_rotatividade has 1533 (76.6%) missing values Missing
vl_faturamento_estimado_aux is highly correlated with total (ρ = 0.9849750322) Rejected
vl_faturamento_estimado_grupo_aux is highly correlated with qt_socios_st_suspensa (ρ = 0.9487115171) Rejected
vl_folha_coligados is highly correlated with qt_socios_pep (ρ = 0.9470885171) Rejected
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.9239805026) Rejected
vl_frota has 1885 (94.2%) missing values Missing
vl_idade_maxima_socios_pj has 1981 (99.1%) missing values Missing
vl_idade_media_socios_pj is highly correlated with vl_idade_maxima_socios_pj (ρ = 0.9804465153) Rejected
vl_idade_minima_socios_pj is highly correlated with vl_idade_media_socios_pj (ρ = 0.9810183741) Rejected
vl_potenc_cons_oleo_gas is highly correlated with vl_folha_coligados_gp (ρ = 0.9999548647) Rejected
vl_total_tancagem has constant value "nan" Rejected
vl_total_tancagem_grupo is highly correlated with vl_folha_coligados_gp (ρ = 1) Rejected
vl_total_veiculos_antt has constant value "nan" Rejected
vl_total_veiculos_antt_grupo has constant value "nan" Rejected
vl_total_veiculos_leves has 32 (1.6%) zeros Zeros
vl_total_veiculos_leves has 1864 (93.2%) missing values Missing
vl_total_veiculos_leves_grupo is highly skewed (γ1 = 44.23709965) Skewed
vl_total_veiculos_leves_grupo has 1834 (91.7%) zeros Zeros
vl_total_veiculos_pesados is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.9118619239) Rejected
vl_total_veiculos_pesados_grupo is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.909344757) Rejected

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count261
Unique (%)13.1%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean219.5476553
Minimum1.766666667
Maximum636.9
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.766666667
5-th percentile39.19666667
Q1117.15
Median193.9666667
Q3280.1833333
95-th percentile538.2966667
Maximum636.9
Range635.1333333
Interquartile range163.0333333

Descriptive statistics

Standard deviation145.1208491
Coef of variation0.6609993121
Kurtosis0.9429744526
Mean219.5476553
MAD111.2763039
Skewness1.092550751
Sum57741.03333
Variance21060.06084
Memory size31.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
247.5 2 0.1%
 
231.1333333 2 0.1%
 
243.7 2 0.1%
 
262.6 1 0.1%
 
71.56666667 1 0.1%
 
538.4666667 1 0.1%
 
113.0666667 1 0.1%
 
294.7666667 1 0.1%
 
163.2666667 1 0.1%
 
358.9666667 1 0.1%
 
Other values (250) 250 12.5%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1.766666667 1 0.1%
 
5.266666667 1 0.1%
 
11.26666667 1 0.1%
 
16.93333333 1 0.1%
 
23.76666667 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
636.9 1 0.1%
 
636.6 1 0.1%
 
636.0333333 1 0.1%
 
635.8 1 0.1%
 
635.0666667 1 0.1%
 

coligada_mais_antiga_baixada
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)> 99.9%
Missing (n)1999
83.96666667
 
1
(Missing)
1999
ValueCountFrequency (%) 
83.96666667 1 0.1%
 
(Missing) 1999 > 99.9%
 
Max length17
Mean length3.007
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

coligada_mais_nova_ativa
Numeric

Distinct count253
Unique (%)12.7%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean116.7159696
Minimum1.533333333
Maximum634.4
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.533333333
5-th percentile4.876666667
Q142.3
Median87.8
Q3176.35
95-th percentile307.98
Maximum634.4
Range632.8666667
Interquartile range134.05

Descriptive statistics

Standard deviation99.60012948
Coef of variation0.8533547708
Kurtosis2.359500176
Mean116.7159696
MAD79.01042664
Skewness1.304812186
Sum30696.3
Variance9920.185791
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
43.7 3 0.1%
 
86.06666667 2 0.1%
 
50.8 2 0.1%
 
37.93333333 2 0.1%
 
37.3 2 0.1%
 
2.7 2 0.1%
 
96.26666667 2 0.1%
 
243.7 2 0.1%
 
4.833333333 2 0.1%
 
3.4 2 0.1%
 
Other values (242) 242 12.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1.533333333 1 0.1%
 
1.766666667 1 0.1%
 
2.466666667 1 0.1%
 
2.5 1 0.1%
 
2.7 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
634.4 1 0.1%
 
407.7333333 1 0.1%
 
389.9666667 1 0.1%
 
369.3333333 1 0.1%
 
365.5666667 1 0.1%
 

coligada_mais_nova_baixada
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)> 99.9%
Missing (n)1999
83.96666667
 
1
(Missing)
1999
ValueCountFrequency (%) 
83.96666667 1 0.1%
 
(Missing) 1999 > 99.9%
 
Max length17
Mean length3.007
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

de_faixa_faturamento_estimado
Categorical

Distinct count10
Unique (%)0.5%
Missing (%)5.9%
Missing (n)118
DE R$ 81.000,01 A R$ 360.000,00
1166
ATE R$ 81.000,00
443
DE R$ 360.000,01 A R$ 1.500.000,00
 
200
Other values (6)
 
73
(Missing)
 
118
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 1166 58.3%
 
ATE R$ 81.000,00 443 22.1%
 
DE R$ 360.000,01 A R$ 1.500.000,00 200 10.0%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 51 2.5%
 
SEM INFORMACAO 6 0.3%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 6 0.3%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 6 0.3%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 3 0.1%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 1 0.1%
 
(Missing) 118 5.9%
 
Max length40
Mean length26.4575
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count12
Unique (%)0.6%
Missing (%)5.9%
Missing (n)118
DE R$ 81.000,01 A R$ 360.000,00
1094
ATE R$ 81.000,00
438
DE R$ 360.000,01 A R$ 1.500.000,00
234
Other values (8)
 
116
(Missing)
 
118
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 1094 54.7%
 
ATE R$ 81.000,00 438 21.9%
 
DE R$ 360.000,01 A R$ 1.500.000,00 234 11.7%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 51 2.5%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 16 0.8%
 
ACIMA DE 1 BILHAO DE REAIS 16 0.8%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 12 0.6%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 8 0.4%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 6 0.3%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 5 0.2%
 
(Missing) 118 5.9%
 
Max length40
Mean length26.682
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)90.2%
Missing (n)1804
BOA
 
196
(Missing)
1804
ValueCountFrequency (%) 
BOA 196 9.8%
 
(Missing) 1804 90.2%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

de_natureza_juridica
Categorical

Distinct count33
Unique (%)1.7%
Missing (%)0.0%
Missing (n)0
EMPRESARIO INDIVIDUAL
1306
SOCIEDADE EMPRESARIA LIMITADA
396
ASSOCIACAO PRIVADA
 
115
Other values (30)
 
183
ValueCountFrequency (%) 
EMPRESARIO INDIVIDUAL 1306 65.3%
 
SOCIEDADE EMPRESARIA LIMITADA 396 19.8%
 
ASSOCIACAO PRIVADA 115 5.8%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 68 3.4%
 
ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO 24 1.2%
 
CANDIDATO A CARGO POLITICO ELETIVO 12 0.6%
 
ENTIDADE SINDICAL 7 0.4%
 
CONDOMINIO EDILICIO 7 0.4%
 
ORGANIZACAO RELIGIOSA 7 0.4%
 
SOCIEDADE SIMPLES LIMITADA 6 0.3%
 
Other values (23) 52 2.6%
 
Max length70
Mean length24.597
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)2.5%
Missing (n)51
MEDIA
933
ALTA
680
BAIXA
321
(Missing)
 
51
ValueCountFrequency (%) 
MEDIA 933 46.7%
 
ALTA 680 34.0%
 
BAIXA 321 16.1%
 
MUITO BAIXA 15 0.8%
 
(Missing) 51 2.5%
 
Max length11
Mean length4.654
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_ramo
Categorical

Distinct count31
Unique (%)1.6%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
749
SERVICOS DIVERSOS
229
SERVICOS DE ALOJAMENTO/ALIMENTACAO
 
133
Other values (28)
889
ValueCountFrequency (%) 
COMERCIO VAREJISTA 749 37.5%
 
SERVICOS DIVERSOS 229 11.5%
 
SERVICOS DE ALOJAMENTO/ALIMENTACAO 133 6.7%
 
INDUSTRIA DA CONSTRUCAO 122 6.1%
 
COMERCIO E REPARACAO DE VEICULOS 115 5.8%
 
SERVICOS ADMINISTRATIVOS 102 5.1%
 
BENS DE CONSUMO 85 4.2%
 
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS 78 3.9%
 
COMERCIO POR ATACADO 63 3.1%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 59 2.9%
 
Other values (21) 265 13.2%
 
Max length49
Mean length22.1755
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)3.2%
Missing (n)64
ACIMA DE 1 ANO
1652
ATE 1 ANO
 
149
SEM INFORMACAO
 
135
(Missing)
 
64
ValueCountFrequency (%) 
ACIMA DE 1 ANO 1652 82.6%
 
ATE 1 ANO 149 7.4%
 
SEM INFORMACAO 135 6.8%
 
(Missing) 64 3.2%
 
Max length14
Mean length13.2755
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count7
Unique (%)0.4%
Missing (%)3.2%
Missing (n)64
VERDE
679
AZUL
471
AMARELO
351
Other values (3)
435
ValueCountFrequency (%) 
VERDE 679 34.0%
 
AZUL 471 23.5%
 
AMARELO 351 17.5%
 
CINZA 262 13.1%
 
LARANJA 150 7.5%
 
VERMELHO 23 1.1%
 
(Missing) 64 3.2%
 
Max length8
Mean length5.236
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count1315
Unique (%)65.8%
Missing (%)0.0%
Missing (n)0
2005-11-03
 
285
2006-12-01
 
13
2005-09-24
 
8
Other values (1312)
1694
ValueCountFrequency (%) 
2005-11-03 285 14.2%
 
2006-12-01 13 0.7%
 
2005-09-24 8 0.4%
 
2018-08-14 7 0.4%
 
2006-12-21 7 0.4%
 
2005-08-27 7 0.4%
 
2006-12-02 7 0.4%
 
2004-10-30 7 0.4%
 
2010-05-15 6 0.3%
 
1998-07-28 6 0.3%
 
Other values (1305) 1647 82.3%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count1231
Unique (%)61.6%
Missing (%)30.0%
Missing (n)600
Infinite (%)0.0%
Infinite (n)0
Mean1342.215271
Minimum169.28
Maximum30861.81
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum169.28
5-th percentile449.453
Q1686.725
Median943.72
Q31539.025
95-th percentile3653.926
Maximum30861.81
Range30692.53
Interquartile range852.3

Descriptive statistics

Standard deviation1340.318374
Coef of variation0.9985867411
Kurtosis173.6273001
Mean1342.215271
MAD752.9107055
Skewness9.216418036
Sum1879101.38
Variance1796453.343
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1549.1 9 0.4%
 
1086.05 6 0.3%
 
845.75 4 0.2%
 
2522.76 4 0.2%
 
1375.69 4 0.2%
 
1116.52 4 0.2%
 
786.74 3 0.1%
 
452.13 3 0.1%
 
1939.11 3 0.1%
 
1519.63 3 0.1%
 
Other values (1220) 1357 67.8%
 
(Missing) 600 30.0%
 

Minimum 5 values

ValueCountFrequency (%) 
169.28 1 0.1%
 
205.66 1 0.1%
 
247.88 1 0.1%
 
255.93 1 0.1%
 
262.44 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
30861.81 1 0.1%
 
12512.93 1 0.1%
 
10039.2 1 0.1%
 
7716.18 1 0.1%
 
6641.43 1 0.1%
 

faturamento_est_coligados
Numeric

Distinct count135
Unique (%)6.8%
Missing (%)86.9%
Missing (n)1738
Infinite (%)0.0%
Infinite (n)0
Mean325097449.3
Minimum50000
Maximum2.775903576e+10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum50000
5-th percentile186684.7141
Q1210000
Median680011.2109
Q32515005.594
95-th percentile151386514.8
Maximum2.775903576e+10
Range2.775898576e+10
Interquartile range2305005.594

Descriptive statistics

Standard deviation2619159438
Coef of variation8.056536414
Kurtosis93.97533198
Mean325097449.3
MAD613818086.9
Skewness9.528882491
Sum8.517553171e+10
Variance6.859996162e+18
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 68 3.4%
 
420000 14 0.7%
 
930000 11 0.5%
 
630000 7 0.4%
 
185457.5938 6 0.3%
 
370915.1875 5 0.2%
 
50000 5 0.2%
 
989107.1875 3 0.1%
 
123638.3984 3 0.1%
 
1260000 3 0.1%
 
Other values (124) 137 6.9%
 
(Missing) 1738 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
50000 5 0.2%
 
123638.3984 3 0.1%
 
185457.5938 6 0.3%
 
210000 68 3.4%
 
247276.7969 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2.775903576e+10 1 0.1%
 
2.753563853e+10 1 0.1%
 
1.508602154e+10 1 0.1%
 
7257133548 1 0.1%
 
2143498799 1 0.1%
 

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.9509546939

fl_antt
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
False
1983
True
 
6
(Missing)
 
11
ValueCountFrequency (%) 
False 1983 99.2%
 
True 6 0.3%
 
(Missing) 11 0.5%
 

fl_email
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1071
True
929
ValueCountFrequency (%) 
False 1071 53.5%
 
True 929 46.5%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1997
True
 
3
ValueCountFrequency (%) 
False 1997 99.9%
 
True 3 0.1%
 

fl_matriz
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
True
1893
False
 
107
ValueCountFrequency (%) 
True 1893 94.7%
 
False 107 5.3%
 

fl_me
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1996
True
 
4
ValueCountFrequency (%) 
False 1996 99.8%
 
True 4 0.2%
 

fl_mei
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1339
True
661
ValueCountFrequency (%) 
False 1339 67.0%
 
True 661 33.1%
 

fl_optante_simei
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)17.3%
Missing (n)346
False
1233
True
421
(Missing)
346
ValueCountFrequency (%) 
False 1233 61.7%
 
True 421 21.1%
 
(Missing) 346 17.3%
 

fl_optante_simples
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)17.3%
Missing (n)346
True
913
False
741
(Missing)
346
ValueCountFrequency (%) 
True 913 45.6%
 
False 741 37.0%
 
(Missing) 346 17.3%
 

fl_passivel_iss
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
True
1141
False
848
(Missing)
 
11
ValueCountFrequency (%) 
True 1141 57.0%
 
False 848 42.4%
 
(Missing) 11 0.5%
 

fl_rm
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
NAO
1008
SIM
992
ValueCountFrequency (%) 
NAO 1008 50.4%
 
SIM 992 49.6%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1964
True
 
36
ValueCountFrequency (%) 
False 1964 98.2%
 
True 36 1.8%
 

fl_simples_irregular
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
False
1987
True
 
2
(Missing)
 
11
ValueCountFrequency (%) 
False 1987 99.4%
 
True 2 0.1%
 
(Missing) 11 0.5%
 

fl_spa
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
False
1989
(Missing)
 
11
ValueCountFrequency (%) 
False 1989 99.5%
 
(Missing) 11 0.5%
 

fl_st_especial
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_telefone
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
True
1459
False
541
ValueCountFrequency (%) 
True 1459 73.0%
 
False 541 27.1%
 

fl_veiculo
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
False
1853
True
 
136
(Missing)
 
11
ValueCountFrequency (%) 
False 1853 92.7%
 
True 136 6.8%
 
(Missing) 11 0.5%
 

grau_instrucao_macro_analfabeto
Categorical

Distinct count3
Unique (%)0.1%
Missing (%)99.7%
Missing (n)1994
1
 
5
3
 
1
(Missing)
1994
ValueCountFrequency (%) 
1 5 0.2%
 
3 1 0.1%
 
(Missing) 1994 99.7%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.9980369909

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count37
Unique (%)1.8%
Missing (%)84.7%
Missing (n)1694
Infinite (%)0.0%
Infinite (n)0
Mean8.637254902
Minimum1
Maximum523
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q36
95-th percentile24.5
Maximum523
Range522
Interquartile range5

Descriptive statistics

Standard deviation33.48847295
Coef of variation3.877212532
Kurtosis185.9186412
Mean8.637254902
MAD9.679418172
Skewness12.63630163
Sum2643
Variance1121.477821
Memory size31.2 KiB
Histogram
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%) 
1 89 4.5%
 
2 56 2.8%
 
3 34 1.7%
 
4 25 1.2%
 
5 17 0.9%
 
6 17 0.9%
 
9 7 0.4%
 
7 7 0.4%
 
8 6 0.3%
 
10 6 0.3%
 
Other values (26) 42 2.1%
 
(Missing) 1694 84.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 89 4.5%
 
2 56 2.8%
 
3 34 1.7%
 
4 25 1.2%
 
5 17 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
523 1 0.1%
 
177 1 0.1%
 
120 1 0.1%
 
94 1 0.1%
 
82 1 0.1%
 

grau_instrucao_macro_escolaridade_superior
Highly correlated

This variable is highly correlated with grau_instrucao_macro_escolaridade_media and should be ignored for analysis

Correlation0.9178829036

id
Categorical, Unique

First 5 values
00123b6e449556823ba4aac6dbb35b44f60557c511566f...
0032e3e6a776cbf4d36efa963b4eda224ddba8af284117...
0036afe9a1be13d5389ab0d8f8cd2217c8c6076345298c...
008fd7836462aaecf8b8d335153ada057577156875fae4...
00c30fb1779762241dd1ca7d1baab00c24b2f87294e573...
Last 5 values
ffba50aa6f4af7271d8f9738018b0f0329c89b05fe5971...
ffc04bac625e91c7ebad8dc98943264661aca3a913b5f6...
ffd37fc0ee78a4555d0c18e10b3779e54581142875f0ad...
ffd81231de150c50400d79d1740ca8108eda5b339beb85...
ffed1e47eaf7b3444605cd7cb91bf9ef7cf3bbe9f7f730...

First 5 values

ValueCountFrequency (%) 
00123b6e449556823ba4aac6dbb35b44f60557c511566f838dc889b75c6f9af1 1 0.1%
 
0032e3e6a776cbf4d36efa963b4eda224ddba8af284117273bbd7a2a9d374f96 1 0.1%
 
0036afe9a1be13d5389ab0d8f8cd2217c8c6076345298cb451f3634f44294ae0 1 0.1%
 
008fd7836462aaecf8b8d335153ada057577156875fae4933a9fc16a2a44e0d0 1 0.1%
 
00c30fb1779762241dd1ca7d1baab00c24b2f87294e573415ccfa23fda43c270 1 0.1%
 

Last 5 values

ValueCountFrequency (%) 
ffed1e47eaf7b3444605cd7cb91bf9ef7cf3bbe9f7f73092c10d21a1d454d1fd 1 0.1%
 
ffd81231de150c50400d79d1740ca8108eda5b339beb850646cdd9424bae405e 1 0.1%
 
ffd37fc0ee78a4555d0c18e10b3779e54581142875f0ad31f9ba0406fd5a9b2d 1 0.1%
 
ffc04bac625e91c7ebad8dc98943264661aca3a913b5f634c2ae69a947772e13 1 0.1%
 
ffba50aa6f4af7271d8f9738018b0f0329c89b05fe597100f833a07065a2c417 1 0.1%
 

idade_acima_de_58
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation1

idade_ate_18
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)99.5%
Missing (n)1990
1
 
7
3
 
2
2
 
1
(Missing)
1990
ValueCountFrequency (%) 
1 7 0.4%
 
3 2 0.1%
 
2 1 0.1%
 
(Missing) 1990 99.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

idade_de_19_a_23
Numeric

Distinct count13
Unique (%)0.7%
Missing (%)94.0%
Missing (n)1879
Infinite (%)0.0%
Infinite (n)0
Mean2.462809917
Minimum1
Maximum43
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile6
Maximum43
Range42
Interquartile range1

Descriptive statistics

Standard deviation4.44792334
Coef of variation1.806035987
Kurtosis58.70447671
Mean2.462809917
MAD1.958745987
Skewness6.926566897
Sum298
Variance19.78402204
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%) 
1 75 3.8%
 
2 19 0.9%
 
3 10 0.5%
 
4 6 0.3%
 
5 4 0.2%
 
11 1 0.1%
 
12 1 0.1%
 
14 1 0.1%
 
10 1 0.1%
 
6 1 0.1%
 
Other values (2) 2 0.1%
 
(Missing) 1879 94.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 75 3.8%
 
2 19 0.9%
 
3 10 0.5%
 
4 6 0.3%
 
5 4 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
43 1 0.1%
 
15 1 0.1%
 
14 1 0.1%
 
12 1 0.1%
 
11 1 0.1%
 

idade_de_24_a_28
Highly correlated

This variable is highly correlated with idade_de_19_a_23 and should be ignored for analysis

Correlation0.9086682511

idade_de_29_a_33
Highly correlated

This variable is highly correlated with grau_instrucao_macro_escolaridade_superior and should be ignored for analysis

Correlation0.9749169386

idade_de_34_a_38
Highly correlated

This variable is highly correlated with idade_de_29_a_33 and should be ignored for analysis

Correlation0.994053508

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.9834868533

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation0.9491747935

idade_de_49_a_53
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.9891584832

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis

Correlation0.9617506252

idade_emp_cat
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
1 a 5
609
5 a 10
523
> 20
329
Other values (3)
539
ValueCountFrequency (%) 
1 a 5 609 30.4%
 
5 a 10 523 26.2%
 
> 20 329 16.4%
 
10 a 15 196 9.8%
 
<= 1 195 9.8%
 
15 a 20 148 7.4%
 
Max length7
Mean length5.3435
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count1669
Unique (%)83.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.945464384
Minimum0.0301369863
Maximum52.11506849
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.0301369863
5-th percentile0.4712328767
Q12.700684932
Median6.646575342
Q314.39109589
95-th percentile30.71863014
Maximum52.11506849
Range52.08493151
Interquartile range11.69041096

Descriptive statistics

Standard deviation9.690644903
Coef of variation0.9743783226
Kurtosis1.386651358
Mean9.945464384
MAD7.607123093
Skewness1.376674689
Sum19890.92877
Variance93.90859864
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[3.01369863e-02 2.04109589e-01 2.09589041e-01 3.59452055e+00 9.28904110e+00 1.44876712e+01 2.41465753e+01 3.32712329e+01 4.19246575e+01 5.21150685e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.2054794521 7 0.4%
 
0.2082191781 5 0.2%
 
0.6054794521 4 0.2%
 
1.254794521 4 0.2%
 
2.394520548 4 0.2%
 
3.460273973 4 0.2%
 
1.02739726 4 0.2%
 
2.216438356 4 0.2%
 
3.060273973 4 0.2%
 
5.194520548 4 0.2%
 
Other values (1659) 1956 97.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0.0301369863 2 0.1%
 
0.04657534247 1 0.1%
 
0.04931506849 1 0.1%
 
0.05205479452 1 0.1%
 
0.05479452055 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
52.11506849 1 0.1%
 
51.15342466 1 0.1%
 
49.43835616 1 0.1%
 
48.27945205 1 0.1%
 
47.3260274 1 0.1%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation0.9997565556

idade_maxima_socios
Numeric

Distinct count73
Unique (%)3.6%
Missing (%)33.0%
Missing (n)659
Infinite (%)0.0%
Infinite (n)0
Mean44.68680089
Minimum18
Maximum96
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum18
5-th percentile25
Q134
Median43
Q354
95-th percentile70
Maximum96
Range78
Interquartile range20

Descriptive statistics

Standard deviation13.94082527
Coef of variation0.3119674041
Kurtosis-0.07141409063
Mean44.68680089
MAD11.35869088
Skewness0.5431259797
Sum59925
Variance194.3466092
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
41 46 2.3%
 
35 43 2.1%
 
30 40 2.0%
 
32 40 2.0%
 
40 39 1.9%
 
45 38 1.9%
 
47 38 1.9%
 
48 37 1.8%
 
39 37 1.8%
 
33 37 1.8%
 
Other values (62) 946 47.3%
 
(Missing) 659 33.0%
 

Minimum 5 values

ValueCountFrequency (%) 
18 1 0.1%
 
19 4 0.2%
 
20 7 0.4%
 
21 7 0.4%
 
22 14 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
96 1 0.1%
 
90 1 0.1%
 
87 2 0.1%
 
86 2 0.1%
 
85 1 0.1%
 

idade_media_coligadas
Numeric

Distinct count262
Unique (%)13.1%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean159.2109782
Minimum1.766666667
Maximum634.4
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.766666667
5-th percentile37.77666667
Q188.3
Median148.6333333
Q3213.65
95-th percentile333.7066667
Maximum634.4
Range632.6333333
Interquartile range125.35

Descriptive statistics

Standard deviation92.85948753
Coef of variation0.5832480184
Kurtosis2.209191276
Mean159.2109782
MAD72.52905633
Skewness1.064459267
Sum41872.48726
Variance8622.884424
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
243.7 2 0.1%
 
87.64444444 2 0.1%
 
262.6 1 0.1%
 
85.85 1 0.1%
 
137.8833333 1 0.1%
 
23.76666667 1 0.1%
 
154.15 1 0.1%
 
121.4111111 1 0.1%
 
47.23333333 1 0.1%
 
16.93333333 1 0.1%
 
Other values (251) 251 12.6%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1.766666667 1 0.1%
 
5.266666667 1 0.1%
 
11.26666667 1 0.1%
 
16.93333333 1 0.1%
 
23.76666667 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
634.4 1 0.1%
 
445.125 1 0.1%
 
407.7333333 1 0.1%
 
395.3333333 1 0.1%
 
392.85 1 0.1%
 

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation0.9996384056

idade_media_coligadas_baixadas
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)> 99.9%
Missing (n)1999
83.96666667
 
1
(Missing)
1999
ValueCountFrequency (%) 
83.96666667 1 0.1%
 
(Missing) 1999 > 99.9%
 
Max length17
Mean length3.007
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

idade_media_socios
Highly correlated

This variable is highly correlated with idade_maxima_socios and should be ignored for analysis

Correlation0.9554366317

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation1

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation0.9505781936

max_faturamento_est_coligados
Highly correlated

This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9359933557

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.9599434338

max_filiais_coligados
Numeric

Distinct count22
Unique (%)1.1%
Missing (%)96.0%
Missing (n)1919
Infinite (%)0.0%
Infinite (n)0
Mean12.38271605
Minimum1
Maximum349
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q35
95-th percentile46
Maximum349
Range348
Interquartile range4

Descriptive statistics

Standard deviation42.61999762
Coef of variation3.441894125
Kurtosis50.59629216
Mean12.38271605
MAD17.06233806
Skewness6.727505967
Sum1003
Variance1816.464198
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%) 
1 37 1.8%
 
2 16 0.8%
 
3 4 0.2%
 
5 3 0.1%
 
8 2 0.1%
 
6 2 0.1%
 
21 2 0.1%
 
4 2 0.1%
 
37 1 0.1%
 
7 1 0.1%
 
Other values (11) 11 0.5%
 
(Missing) 1919 96.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 37 1.8%
 
2 16 0.8%
 
3 4 0.2%
 
4 2 0.1%
 
5 3 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
349 1 0.1%
 
144 1 0.1%
 
67 1 0.1%
 
49 1 0.1%
 
46 1 0.1%
 

max_funcionarios_coligados_gp
Numeric

Distinct count61
Unique (%)3.0%
Missing (%)91.5%
Missing (n)1830
Infinite (%)0.0%
Infinite (n)0
Mean277.2647059
Minimum0
Maximum13234
Zeros (%)1.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q12
Median7
Q321
95-th percentile917.5
Maximum13234
Range13234
Interquartile range19

Descriptive statistics

Standard deviation1358.472975
Coef of variation4.899552471
Kurtosis58.60802041
Mean277.2647059
MAD469.5352941
Skewness7.258593967
Sum47135
Variance1845448.823
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 28 1.4%
 
1 14 0.7%
 
8 10 0.5%
 
3 9 0.4%
 
6 9 0.4%
 
2 8 0.4%
 
4 7 0.4%
 
5 7 0.4%
 
7 5 0.2%
 
12 4 0.2%
 
Other values (50) 69 3.5%
 
(Missing) 1830 91.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 28 1.4%
 
1 14 0.7%
 
2 8 0.4%
 
3 9 0.4%
 
4 7 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
13234 1 0.1%
 
7646 1 0.1%
 
7612 1 0.1%
 
3719 1 0.1%
 
3278 1 0.1%
 

max_meses_servicos
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.9664890124

max_meses_servicos_all
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.9664890124

max_vl_folha_coligados
Numeric

Distinct count80
Unique (%)4.0%
Missing (%)92.9%
Missing (n)1858
Infinite (%)0.0%
Infinite (n)0
Mean17759814.38
Minimum20606.4
Maximum1002336500
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20606.4
5-th percentile61819.2
Q1185457.6
Median556372.8
Q31375477.2
95-th percentile49336874
Maximum1002336500
Range1002315894
Interquartile range1190019.6

Descriptive statistics

Standard deviation94405468.23
Coef of variation5.315678767
Kurtosis87.64999342
Mean17759814.38
MAD29605044.23
Skewness8.890949332
Sum2521893642
Variance8.912392432e+15
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
61819.2 15 0.8%
 
247276.8 7 0.4%
 
123638.4 6 0.3%
 
185457.6 6 0.3%
 
494553.6 4 0.2%
 
329702.4 3 0.1%
 
432734.4 3 0.1%
 
618192 3 0.1%
 
309096 3 0.1%
 
206064 3 0.1%
 
Other values (69) 89 4.5%
 
(Missing) 1858 92.9%
 

Minimum 5 values

ValueCountFrequency (%) 
20606.4 2 0.1%
 
41212.8 1 0.1%
 
61819.2 15 0.8%
 
82425.6 2 0.1%
 
103032 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1002336500 1 0.1%
 
442419400 1 0.1%
 
194709870 1 0.1%
 
134910100 1 0.1%
 
130871250 1 0.1%
 

max_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9048394021

media_faturamento_est_coligados
Numeric

Distinct count130
Unique (%)6.5%
Missing (%)86.9%
Missing (n)1738
Infinite (%)0.0%
Infinite (n)0
Mean13597728.61
Minimum50000
Maximum1321858846
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum50000
5-th percentile182433.1797
Q1210000
Median310976.5714
Q3930000
95-th percentile14443904.07
Maximum1321858846
Range1321808846
Interquartile range720000

Descriptive statistics

Standard deviation97682086.91
Coef of variation7.183706168
Kurtosis129.9251177
Mean13597728.61
MAD24051830
Skewness10.66475957
Sum3562604897
Variance9.541790104e+15
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 95 4.8%
 
930000 12 0.6%
 
185457.5938 6 0.3%
 
370915.1875 5 0.2%
 
50000 5 0.2%
 
989107.1875 3 0.1%
 
166819.1992 2 0.1%
 
228638.3984 2 0.1%
 
182274 2 0.1%
 
123638.3984 2 0.1%
 
Other values (119) 128 6.4%
 
(Missing) 1738 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
50000 5 0.2%
 
61819.19922 1 0.1%
 
123638.3984 2 0.1%
 
153737.6003 1 0.1%
 
166819.1992 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1321858846 1 0.1%
 
518366682 1 0.1%
 
502867384.6 1 0.1%
 
441742236 1 0.1%
 
235347337.9 1 0.1%
 

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.9503777089

media_filiais_coligados
Numeric

Distinct count30
Unique (%)1.5%
Missing (%)96.0%
Missing (n)1919
Infinite (%)0.0%
Infinite (n)0
Mean4.430688276
Minimum1
Maximum67
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1.5
Q33
95-th percentile14.5
Maximum67
Range66
Interquartile range2

Descriptive statistics

Standard deviation9.535549907
Coef of variation2.152159961
Kurtosis28.7355447
Mean4.430688276
MAD4.605814278
Skewness5.072445182
Sum358.8857504
Variance90.92671204
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%) 
1 37 1.8%
 
2 11 0.5%
 
1.5 4 0.2%
 
3 3 0.1%
 
4.5 2 0.1%
 
1.666666667 1 0.1%
 
14.5 1 0.1%
 
2.5 1 0.1%
 
4 1 0.1%
 
8.5 1 0.1%
 
Other values (19) 19 0.9%
 
(Missing) 1919 96.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 37 1.8%
 
1.333333333 1 0.1%
 
1.5 4 0.2%
 
1.666666667 1 0.1%
 
2 11 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
67 1 0.1%
 
49.4 1 0.1%
 
20.66666667 1 0.1%
 
18 1 0.1%
 
14.5 1 0.1%
 

media_funcionarios_coligados_gp
Numeric

Distinct count71
Unique (%)3.5%
Missing (%)91.5%
Missing (n)1830
Infinite (%)0.0%
Infinite (n)0
Mean53.77076285
Minimum0
Maximum2162.357143
Zeros (%)1.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11.25
Median6
Q316
95-th percentile195.88125
Maximum2162.357143
Range2162.357143
Interquartile range14.75

Descriptive statistics

Standard deviation213.8766555
Coef of variation3.977564092
Kurtosis63.0354861
Mean53.77076285
MAD80.96236244
Skewness7.368189486
Sum9141.029685
Variance45743.22378
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 28 1.4%
 
1 14 0.7%
 
6 10 0.5%
 
2 10 0.5%
 
3 9 0.4%
 
8 8 0.4%
 
5 7 0.4%
 
4 6 0.3%
 
21 6 0.3%
 
7 5 0.2%
 
Other values (60) 67 3.4%
 
(Missing) 1830 91.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 28 1.4%
 
0.6666666667 1 0.1%
 
1 14 0.7%
 
2 10 0.5%
 
3 9 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2162.357143 1 0.1%
 
1254.75 1 0.1%
 
931 1 0.1%
 
546 1 0.1%
 
479.8333333 1 0.1%
 

media_meses_servicos
Highly correlated

This variable is highly correlated with max_meses_servicos and should be ignored for analysis

Correlation0.9868452786

media_meses_servicos_all
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.9765604493

media_vl_folha_coligados
Numeric

Distinct count96
Unique (%)4.8%
Missing (%)92.9%
Missing (n)1858
Infinite (%)0.0%
Infinite (n)0
Mean4118832.88
Minimum20606.40039
Maximum134910096
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20606.40039
5-th percentile61819.19922
Q1185457.5938
Median443037.6094
Q31133352
95-th percentile11696119.15
Maximum134910096
Range134889489.6
Interquartile range947894.4062

Descriptive statistics

Standard deviation16323453.39
Coef of variation3.963125931
Kurtosis45.65863081
Mean4118832.88
MAD6159844.549
Skewness6.523508433
Sum584874269
Variance2.664551306e+14
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
61819.19922 15 0.8%
 
185457.5938 6 0.3%
 
123638.3984 5 0.2%
 
247276.7969 4 0.2%
 
329702.4062 3 0.1%
 
309096 3 0.1%
 
206064 3 0.1%
 
494553.5938 3 0.1%
 
370915.1875 3 0.1%
 
1050926.375 2 0.1%
 
Other values (85) 95 4.8%
 
(Missing) 1858 92.9%
 

Minimum 5 values

ValueCountFrequency (%) 
20606.40039 2 0.1%
 
41212.80078 1 0.1%
 
61819.19922 15 0.8%
 
61819.20117 1 0.1%
 
82425.60156 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
134910096 1 0.1%
 
116297026.5 1 0.1%
 
65404711.85 1 0.1%
 
41406182.86 1 0.1%
 
28189555.55 1 0.1%
 

media_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with media_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9041231022

meses_ultima_contratacaco
Numeric

Distinct count254
Unique (%)12.7%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean40.5289793
Minimum2.066666667
Maximum325.5333333
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.066666667
5-th percentile3.253333333
Q110
Median32.73333333
Q358.16666667
95-th percentile106.22
Maximum325.5333333
Range323.4666667
Interquartile range48.16666667

Descriptive statistics

Standard deviation37.4965795
Coef of variation0.9251794678
Kurtosis8.371662919
Mean40.5289793
MAD27.83812052
Skewness2.033555459
Sum18927.03333
Variance1405.993474
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
5.966666667 13 0.7%
 
2.933333333 10 0.5%
 
40.5 9 0.4%
 
8.033333333 8 0.4%
 
26.23333333 7 0.4%
 
6.966666667 7 0.4%
 
39.46666667 7 0.4%
 
7 6 0.3%
 
23.2 6 0.3%
 
24.2 6 0.3%
 
Other values (243) 388 19.4%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
2.066666667 1 0.1%
 
2.133333333 1 0.1%
 
2.166666667 1 0.1%
 
2.3 1 0.1%
 
2.4 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
325.5333333 1 0.1%
 
222.0666667 1 0.1%
 
178.4 1 0.1%
 
168.2 1 0.1%
 
167.2333333 1 0.1%
 

min_faturamento_est_coligados
Numeric

Distinct count42
Unique (%)2.1%
Missing (%)86.9%
Missing (n)1738
Infinite (%)0.0%
Infinite (n)0
Mean446924.3031
Minimum13946
Maximum14465693
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum13946
5-th percentile83804.32
Q1210000
Median210000
Q3210000
95-th percentile1112745.6
Maximum14465693
Range14451747
Interquartile range0

Descriptive statistics

Standard deviation1052321.548
Coef of variation2.354585645
Kurtosis122.7846314
Mean446924.3031
MAD410365.8844
Skewness9.858228338
Sum117094167.4
Variance1.107380641e+12
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%) 
210000 159 8.0%
 
930000 15 0.8%
 
185457.6 13 0.7%
 
123638.4 13 0.7%
 
370915.2 6 0.3%
 
50000 5 0.2%
 
989107.2 4 0.2%
 
247276.8 4 0.2%
 
206064 3 0.1%
 
82425.6 2 0.1%
 
Other values (31) 38 1.9%
 
(Missing) 1738 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
13946 1 0.1%
 
19079 1 0.1%
 
41212.8 2 0.1%
 
50000 5 0.2%
 
51516 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
14465693 1 0.1%
 
4657046.5 1 0.1%
 
3791577.5 1 0.1%
 
3585513.5 1 0.1%
 
3193992 1 0.1%
 

min_faturamento_est_coligados_gp
Numeric

Distinct count56
Unique (%)2.8%
Missing (%)86.9%
Missing (n)1738
Infinite (%)0.0%
Infinite (n)0
Mean841766.8011
Minimum19079
Maximum81345780
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum19079
5-th percentile123638.4
Q1210000
Median210000
Q3420000
95-th percentile1854576
Maximum81345780
Range81326701
Interquartile range210000

Descriptive statistics

Standard deviation5121975.978
Coef of variation6.084792096
Kurtosis236.4369519
Mean841766.8011
MAD999267.4416
Skewness15.07431753
Sum220542901.9
Variance2.623463792e+13
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
210000 145 7.2%
 
930000 14 0.7%
 
123638.4 13 0.7%
 
185457.6 9 0.4%
 
420000 8 0.4%
 
370915.2 5 0.2%
 
50000 5 0.2%
 
630000 4 0.2%
 
247276.8 3 0.1%
 
1112745.6 3 0.1%
 
Other values (45) 53 2.6%
 
(Missing) 1738 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
19079 1 0.1%
 
41212.8 2 0.1%
 
50000 5 0.2%
 
51516 1 0.1%
 
61819.2 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
81345780 1 0.1%
 
14675693 1 0.1%
 
5608877 1 0.1%
 
4657046.5 1 0.1%
 
4450982.5 1 0.1%
 

min_filiais_coligados
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.942216953

min_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with min_filiais_coligados and should be ignored for analysis

Correlation0.9051143156

min_meses_servicos
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation0.9357049853

min_meses_servicos_all
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.9830648574

min_vl_folha_coligados
Numeric

Distinct count47
Unique (%)2.4%
Missing (%)92.9%
Missing (n)1858
Infinite (%)0.0%
Infinite (n)0
Mean1426195.058
Minimum0
Maximum134910100
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile41212.8
Q161819.2
Median206064
Q3494553.6
95-th percentile1421841.6
Maximum134910100
Range134910100
Interquartile range432734.4

Descriptive statistics

Standard deviation11334339.33
Coef of variation7.947257469
Kurtosis139.3003108
Mean1426195.058
MAD2115644.891
Skewness11.7534269
Sum202519698.3
Variance1.284672481e+14
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%) 
61819.2 28 1.4%
 
123638.4 12 0.6%
 
185457.6 8 0.4%
 
329702.4 6 0.3%
 
103032 5 0.2%
 
20606.4 5 0.2%
 
206064 5 0.2%
 
494553.6 4 0.2%
 
618192 4 0.2%
 
247276.8 4 0.2%
 
Other values (36) 61 3.0%
 
(Missing) 1858 92.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2 0.1%
 
20606.4 5 0.2%
 
41212.8 3 0.1%
 
61819.2 28 1.4%
 
82425.6 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
134910100 1 0.1%
 
10365019 1 0.1%
 
7232846.5 1 0.1%
 
2328523.2 1 0.1%
 
1916395.2 1 0.1%
 

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis

Correlation0.9817628137

natureza_juridica_macro
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
OUTROS
1406
ENTIDADES EMPRESARIAIS
426
ENTIDADES SEM FINS LUCRATIVOS
 
137
Other values (3)
 
31
ValueCountFrequency (%) 
OUTROS 1406 70.3%
 
ENTIDADES EMPRESARIAIS 426 21.3%
 
ENTIDADES SEM FINS LUCRATIVOS 137 6.9%
 
ADMINISTRACAO PUBLICA 15 0.8%
 
CARGO POLITICO 12 0.6%
 
PESSOAS FISICAS 4 0.2%
 
Max length29
Mean length11.162
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count72
Unique (%)3.6%
Missing (%)0.5%
Missing (n)11
COMERCIO VAREJISTA
749
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS
 
140
ALIMENTACAO
 
121
Other values (68)
979
ValueCountFrequency (%) 
COMERCIO VAREJISTA 749 37.5%
 
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS 140 7.0%
 
ALIMENTACAO 121 6.0%
 
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 115 5.8%
 
SERVICOS ESPECIALIZADOS PARA CONSTRUCAO 73 3.6%
 
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS 63 3.1%
 
OUTRAS ATIVIDADES DE SERVICOS PESSOAIS 54 2.7%
 
SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS 52 2.6%
 
EDUCACAO 48 2.4%
 
CONSTRUCAO DE EDIFICIOS 42 2.1%
 
Other values (61) 532 26.6%
 
Max length120
Mean length33.6125
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)1.0%
Missing (%)13.9%
Missing (n)278
CENTRO AMAZONENSE
319
LESTE POTIGUAR
264
NORTE MARANHENSE
263
Other values (16)
876
(Missing)
278
ValueCountFrequency (%) 
CENTRO AMAZONENSE 319 16.0%
 
LESTE POTIGUAR 264 13.2%
 
NORTE MARANHENSE 263 13.2%
 
CENTRO NORTE PIAUIENSE 165 8.2%
 
OESTE MARANHENSE 101 5.1%
 
VALE DO ACRE 83 4.2%
 
OESTE POTIGUAR 78 3.9%
 
LESTE MARANHENSE 77 3.9%
 
SUDOESTE PIAUIENSE 59 2.9%
 
CENTRO MARANHENSE 59 2.9%
 
Other values (9) 254 12.7%
 
(Missing) 278 13.9%
 
Max length22
Mean length14.3615
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count73
Unique (%)3.6%
Missing (%)13.9%
Missing (n)278
MANAUS
256
NATAL
216
AGLOMERACAO URBANA DE SAO LUIS
 
206
Other values (69)
1044
(Missing)
278
ValueCountFrequency (%) 
MANAUS 256 12.8%
 
NATAL 216 10.8%
 
AGLOMERACAO URBANA DE SAO LUIS 206 10.3%
 
TERESINA 142 7.1%
 
RIO BRANCO 70 3.5%
 
IMPERATRIZ 56 2.8%
 
MOSSORO 39 1.9%
 
MEDIO MEARIM 35 1.8%
 
CAXIAS 32 1.6%
 
PINDARE 31 1.6%
 
Other values (62) 639 31.9%
 
(Missing) 278 13.9%
 
Max length33
Mean length11.012
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count21
Unique (%)1.1%
Missing (%)0.5%
Missing (n)11
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
927
OUTRAS ATIVIDADES DE SERVICOS
223
INDUSTRIAS DE TRANSFORMACAO
 
140
Other values (17)
699
ValueCountFrequency (%) 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 927 46.4%
 
OUTRAS ATIVIDADES DE SERVICOS 223 11.2%
 
INDUSTRIAS DE TRANSFORMACAO 140 7.0%
 
ALOJAMENTO E ALIMENTACAO 133 6.7%
 
CONSTRUCAO 122 6.1%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 102 5.1%
 
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS 78 3.9%
 
TRANSPORTE ARMAZENAGEM E CORREIO 59 2.9%
 
SAUDE HUMANA E SERVICOS SOCIAIS 50 2.5%
 
EDUCACAO 48 2.4%
 
Other values (10) 107 5.3%
 
Max length62
Mean length42.663
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count26
Unique (%)1.3%
Missing (%)10.0%
Missing (n)199
Infinite (%)0.0%
Infinite (n)0
Mean25.31260411
Minimum7
Maximum54
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7
5-th percentile9
Q122
Median23
Q325
95-th percentile48
Maximum54
Range47
Interquartile range3

Descriptive statistics

Standard deviation9.684724624
Coef of variation0.3826048313
Kurtosis1.859388261
Mean25.31260411
MAD5.9891232
Skewness1.277543731
Sum45588
Variance93.79389105
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%) 
23 479 23.9%
 
22 357 17.8%
 
24 197 9.8%
 
48 125 6.2%
 
25 115 5.8%
 
26 113 5.7%
 
27 87 4.3%
 
21 51 2.5%
 
9 48 2.4%
 
47 39 1.9%
 
Other values (15) 190 9.5%
 
(Missing) 199 10.0%
 

Minimum 5 values

ValueCountFrequency (%) 
7 39 1.9%
 
8 17 0.9%
 
9 48 2.4%
 
10 16 0.8%
 
11 17 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
54 10 0.5%
 
52 3 0.1%
 
50 24 1.2%
 
49 20 1.0%
 
48 125 6.2%
 

percent_func_genero_fem
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.9457217032

percent_func_genero_masc
Numeric

Distinct count65
Unique (%)3.2%
Missing (%)83.0%
Missing (n)1659
Infinite (%)0.0%
Infinite (n)0
Mean53.98489736
Minimum0
Maximum100
Zeros (%)4.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q112.5
Median57.14
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range87.5

Descriptive statistics

Standard deviation39.18282514
Coef of variation0.7258108667
Kurtosis-1.493931653
Mean53.98489736
MAD34.86371118
Skewness-0.181502856
Sum18408.85
Variance1535.293786
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
100 94 4.7%
 
0 83 4.2%
 
50 28 1.4%
 
66.67 15 0.8%
 
33.33 13 0.7%
 
75 8 0.4%
 
83.33 7 0.4%
 
60 7 0.4%
 
25 7 0.4%
 
80 4 0.2%
 
Other values (54) 75 3.8%
 
(Missing) 1659 83.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 83 4.2%
 
11.11 2 0.1%
 
12.5 1 0.1%
 
14.29 1 0.1%
 
16 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 94 4.7%
 
98.04 1 0.1%
 
93.33 2 0.1%
 
93.24 1 0.1%
 
92.31 1 0.1%
 

qt_admitidos
Numeric

Distinct count85
Unique (%)4.2%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean35.05567452
Minimum1
Maximum2000
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median6
Q318
95-th percentile147.8
Maximum2000
Range1999
Interquartile range16

Descriptive statistics

Standard deviation144.849282
Coef of variation4.131978174
Kurtosis124.459545
Mean35.05567452
MAD46.63998643
Skewness10.32530733
Sum16371
Variance20981.31449
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 75 3.8%
 
2 55 2.8%
 
3 33 1.7%
 
4 30 1.5%
 
6 22 1.1%
 
5 21 1.1%
 
8 17 0.9%
 
7 17 0.9%
 
9 15 0.8%
 
17 11 0.5%
 
Other values (74) 171 8.6%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 75 3.8%
 
2 55 2.8%
 
3 33 1.7%
 
4 30 1.5%
 
5 21 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2000 1 0.1%
 
1812 1 0.1%
 
890 1 0.1%
 
687 1 0.1%
 
647 1 0.1%
 

qt_admitidos_12meses
Numeric

Distinct count22
Unique (%)1.1%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean1.209850107
Minimum0
Maximum65
Zeros (%)17.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile6
Maximum65
Range65
Interquartile range1

Descriptive statistics

Standard deviation4.841131596
Coef of variation4.001430894
Kurtosis87.57457722
Mean1.209850107
MAD1.830445369
Skewness8.343214083
Sum565
Variance23.43655513
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%) 
0 342 17.1%
 
1 65 3.2%
 
2 16 0.8%
 
3 10 0.5%
 
4 7 0.4%
 
6 6 0.3%
 
12 4 0.2%
 
5 2 0.1%
 
7 2 0.1%
 
14 2 0.1%
 
Other values (11) 11 0.5%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 342 17.1%
 
1 65 3.2%
 
2 16 0.8%
 
3 10 0.5%
 
4 7 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
65 1 0.1%
 
46 1 0.1%
 
35 1 0.1%
 
28 1 0.1%
 
21 1 0.1%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Numeric

Distinct count8
Unique (%)0.4%
Missing (%)98.7%
Missing (n)1974
Infinite (%)0.0%
Infinite (n)0
Mean2.846153846
Minimum1
Maximum14
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33
95-th percentile10.25
Maximum14
Range13
Interquartile range2

Descriptive statistics

Standard deviation3.270379889
Coef of variation1.149052393
Kurtosis5.838414503
Mean2.846153846
MAD2.094674556
Skewness2.474656468
Sum74
Variance10.69538462
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 12 0.6%
 
2 6 0.3%
 
3 4 0.2%
 
14 1 0.1%
 
5 1 0.1%
 
11 1 0.1%
 
8 1 0.1%
 
(Missing) 1974 98.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 12 0.6%
 
2 6 0.3%
 
3 4 0.2%
 
5 1 0.1%
 
8 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
14 1 0.1%
 
11 1 0.1%
 
8 1 0.1%
 
5 1 0.1%
 
3 4 0.2%
 

qt_coligadas
Numeric

Distinct count14
Unique (%)0.7%
Missing (%)89.5%
Missing (n)1791
Infinite (%)0.0%
Infinite (n)0
Mean2.291866029
Minimum1
Maximum26
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile7
Maximum26
Range25
Interquartile range1

Descriptive statistics

Standard deviation2.688290288
Coef of variation1.172970084
Kurtosis31.34631573
Mean2.291866029
MAD1.599185
Skewness4.591695706
Sum479
Variance7.226904674
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%) 
1 121 6.0%
 
2 37 1.8%
 
3 18 0.9%
 
5 10 0.5%
 
4 6 0.3%
 
7 5 0.2%
 
6 4 0.2%
 
8 3 0.1%
 
26 1 0.1%
 
14 1 0.1%
 
Other values (3) 3 0.1%
 
(Missing) 1791 89.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 121 6.0%
 
2 37 1.8%
 
3 18 0.9%
 
4 6 0.3%
 
5 10 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
26 1 0.1%
 
14 1 0.1%
 
13 1 0.1%
 
11 1 0.1%
 
9 1 0.1%
 

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.9950754524

qt_coligados_agropecuaria
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
248
1
 
11
2
 
3
(Missing)
1737
ValueCountFrequency (%) 
0 248 12.4%
 
1 11 0.5%
 
2 3 0.1%
 
4 1 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_atividade_alto
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
263
(Missing)
1737
ValueCountFrequency (%) 
0 263 13.2%
 
(Missing) 1737 86.9%
 

qt_coligados_atividade_baixo
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
263
(Missing)
1737
ValueCountFrequency (%) 
0 263 13.2%
 
(Missing) 1737 86.9%
 

qt_coligados_atividade_inativo
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
263
(Missing)
1737
ValueCountFrequency (%) 
0 263 13.2%
 
(Missing) 1737 86.9%
 

qt_coligados_atividade_medio
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
263
(Missing)
1737
ValueCountFrequency (%) 
0 263 13.2%
 
(Missing) 1737 86.9%
 

qt_coligados_atividade_mt_baixo
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
263
(Missing)
1737
ValueCountFrequency (%) 
0 263 13.2%
 
(Missing) 1737 86.9%
 

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.9922537325

qt_coligados_baixada
Highly correlated

This variable is highly correlated with min_vl_folha_coligados_gp and should be ignored for analysis

Correlation0.9776137125

qt_coligados_ccivil
Numeric

Distinct count7
Unique (%)0.4%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.3536121673
Minimum0
Maximum6
Zeros (%)10.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum6
Range6
Interquartile range0

Descriptive statistics

Standard deviation0.9330939842
Coef of variation2.638749654
Kurtosis16.15012997
Mean0.3536121673
MAD0.5700819731
Skewness3.727535875
Sum93
Variance0.8706643834
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 212 10.6%
 
1 30 1.5%
 
2 12 0.6%
 
3 4 0.2%
 
5 3 0.1%
 
6 2 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 212 10.6%
 
1 30 1.5%
 
2 12 0.6%
 
3 4 0.2%
 
5 3 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6 2 0.1%
 
5 3 0.1%
 
3 4 0.2%
 
2 12 0.6%
 
1 30 1.5%
 

qt_coligados_centro
Numeric

Distinct count6
Unique (%)0.3%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.08745247148
Minimum0
Maximum6
Zeros (%)12.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum6
Range6
Interquartile range0

Descriptive statistics

Standard deviation0.6021228133
Coef of variation6.885143474
Kurtosis74.31706993
Mean0.08745247148
MAD0.1695846405
Skewness8.314029607
Sum23
Variance0.3625518823
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 255 12.8%
 
1 3 0.1%
 
3 2 0.1%
 
6 2 0.1%
 
2 1 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 255 12.8%
 
1 3 0.1%
 
2 1 0.1%
 
3 2 0.1%
 
6 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6 2 0.1%
 
3 2 0.1%
 
2 1 0.1%
 
1 3 0.1%
 
0 255 12.8%
 

qt_coligados_comercio
Numeric

Distinct count14
Unique (%)0.7%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.9961977186
Minimum0
Maximum20
Zeros (%)7.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile4
Maximum20
Range20
Interquartile range1

Descriptive statistics

Standard deviation2.061086386
Coef of variation2.068953128
Kurtosis32.12491127
Mean0.9961977186
MAD1.090893319
Skewness4.767635124
Sum262
Variance4.248077091
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%) 
0 144 7.2%
 
1 70 3.5%
 
2 27 1.4%
 
3 7 0.4%
 
8 3 0.1%
 
6 3 0.1%
 
4 2 0.1%
 
5 2 0.1%
 
10 1 0.1%
 
7 1 0.1%
 
Other values (3) 3 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 144 7.2%
 
1 70 3.5%
 
2 27 1.4%
 
3 7 0.4%
 
4 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
20 1 0.1%
 
11 1 0.1%
 
10 1 0.1%
 
9 1 0.1%
 
8 3 0.1%
 

qt_coligados_epp
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
263
(Missing)
1737
ValueCountFrequency (%) 
0 263 13.2%
 
(Missing) 1737 86.9%
 

qt_coligados_exterior
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
257
2
 
3
1
 
2
(Missing)
1737
ValueCountFrequency (%) 
0 257 12.8%
 
2 3 0.1%
 
1 2 0.1%
 
3 1 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_inapta
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
258
1
 
3
2
 
2
(Missing)
1737
ValueCountFrequency (%) 
0 258 12.9%
 
1 3 0.1%
 
2 2 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_industria
Numeric

Distinct count7
Unique (%)0.4%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.6425855513
Minimum0
Maximum111
Zeros (%)11.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum111
Range111
Interquartile range0

Descriptive statistics

Standard deviation6.902926429
Coef of variation10.74242397
Kurtosis252.1246012
Mean0.6425855513
MAD1.11902731
Skewness15.74305704
Sum169
Variance47.65039329
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 229 11.5%
 
1 24 1.2%
 
3 4 0.2%
 
2 4 0.2%
 
111 1 0.1%
 
14 1 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 229 11.5%
 
1 24 1.2%
 
2 4 0.2%
 
3 4 0.2%
 
14 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
111 1 0.1%
 
14 1 0.1%
 
3 4 0.2%
 
2 4 0.2%
 
1 24 1.2%
 

qt_coligados_ltda
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
251
1
 
9
2
 
3
(Missing)
1737
ValueCountFrequency (%) 
0 251 12.6%
 
1 9 0.4%
 
2 3 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.9940913825

qt_coligados_me
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
262
1
 
1
(Missing)
1737
ValueCountFrequency (%) 
0 262 13.1%
 
1 1 0.1%
 
(Missing) 1737 86.9%
 

qt_coligados_mei
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
255
1
 
7
2
 
1
(Missing)
1737
ValueCountFrequency (%) 
0 255 12.8%
 
1 7 0.4%
 
2 1 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_nordeste
Numeric

Distinct count17
Unique (%)0.9%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean2
Minimum0
Maximum36
Zeros (%)4.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile7
Maximum36
Range36
Interquartile range2

Descriptive statistics

Standard deviation4.009530631
Coef of variation2.004765315
Kurtosis34.70289867
Mean2
MAD2.038022814
Skewness5.240064904
Sum526
Variance16.07633588
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%) 
0 93 4.7%
 
1 82 4.1%
 
2 38 1.9%
 
3 13 0.7%
 
5 8 0.4%
 
6 6 0.3%
 
7 6 0.3%
 
4 5 0.2%
 
8 5 0.2%
 
16 1 0.1%
 
Other values (6) 6 0.3%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 93 4.7%
 
1 82 4.1%
 
2 38 1.9%
 
3 13 0.7%
 
4 5 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
36 1 0.1%
 
31 1 0.1%
 
25 1 0.1%
 
20 1 0.1%
 
16 1 0.1%
 

qt_coligados_norte
Highly correlated

This variable is highly correlated with idade_ate_18 and should be ignored for analysis

Correlation0.9001915505

qt_coligados_nula
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
263
(Missing)
1737
ValueCountFrequency (%) 
0 263 13.2%
 
(Missing) 1737 86.9%
 

qt_coligados_sa
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.9176972372

qt_coligados_serviço
Numeric

Distinct count17
Unique (%)0.9%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean1.768060837
Minimum0
Maximum20
Zeros (%)4.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile7
Maximum20
Range20
Interquartile range2

Descriptive statistics

Standard deviation2.890397177
Coef of variation1.63478378
Kurtosis14.51365162
Mean1.768060837
MAD1.804739117
Skewness3.352582746
Sum465
Variance8.354395844
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%) 
0 96 4.8%
 
1 88 4.4%
 
2 27 1.4%
 
3 15 0.8%
 
7 9 0.4%
 
4 7 0.4%
 
5 6 0.3%
 
6 4 0.2%
 
8 4 0.2%
 
17 1 0.1%
 
Other values (6) 6 0.3%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 96 4.8%
 
1 88 4.4%
 
2 27 1.4%
 
3 15 0.8%
 
4 7 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
20 1 0.1%
 
19 1 0.1%
 
17 1 0.1%
 
15 1 0.1%
 
11 1 0.1%
 

qt_coligados_sudeste
Highly correlated

This variable is highly correlated with qt_coligados_sa and should be ignored for analysis

Correlation0.9150368291

qt_coligados_sul
Numeric

Distinct count6
Unique (%)0.3%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.04562737643
Minimum0
Maximum5
Zeros (%)12.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.3880489044
Coef of variation8.504738489
Kurtosis116.6502915
Mean0.04562737643
MAD0.08951987162
Skewness10.30566678
Sum12
Variance0.1505819522
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 258 12.9%
 
1 2 0.1%
 
2 1 0.1%
 
3 1 0.1%
 
5 1 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 258 12.9%
 
1 2 0.1%
 
2 1 0.1%
 
3 1 0.1%
 
5 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 0.1%
 
3 1 0.1%
 
2 1 0.1%
 
1 2 0.1%
 
0 258 12.9%
 

qt_coligados_suspensa
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
263
(Missing)
1737
ValueCountFrequency (%) 
0 263 13.2%
 
(Missing) 1737 86.9%
 

qt_desligados
Numeric

Distinct count76
Unique (%)3.8%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean25.1006424
Minimum0
Maximum1985
Zeros (%)2.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median4
Q312
95-th percentile107.1
Maximum1985
Range1985
Interquartile range11

Descriptive statistics

Standard deviation112.3499311
Coef of variation4.475978316
Kurtosis207.5163615
Mean25.1006424
MAD34.37883616
Skewness12.95798816
Sum11722
Variance12622.50702
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 81 4.0%
 
2 57 2.9%
 
0 54 2.7%
 
4 32 1.6%
 
3 26 1.3%
 
6 24 1.2%
 
5 17 0.9%
 
7 15 0.8%
 
11 14 0.7%
 
8 11 0.5%
 
Other values (65) 136 6.8%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 54 2.7%
 
1 81 4.0%
 
2 57 2.9%
 
3 26 1.3%
 
4 32 1.6%
 

Maximum 5 values

ValueCountFrequency (%) 
1985 1 0.1%
 
865 1 0.1%
 
585 1 0.1%
 
451 2 0.1%
 
290 1 0.1%
 

qt_desligados_12meses
Numeric

Distinct count17
Unique (%)0.9%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean1.468950749
Minimum0
Maximum233
Zeros (%)16.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile4
Maximum233
Range233
Interquartile range1

Descriptive statistics

Standard deviation11.1897696
Coef of variation7.61752537
Kurtosis395.8513046
Mean1.468950749
MAD2.211124816
Skewness19.24610978
Sum686
Variance125.2109437
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%) 
0 332 16.6%
 
1 61 3.0%
 
2 23 1.1%
 
3 17 0.9%
 
4 11 0.5%
 
6 6 0.3%
 
5 4 0.2%
 
10 3 0.1%
 
9 2 0.1%
 
25 2 0.1%
 
Other values (6) 6 0.3%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 332 16.6%
 
1 61 3.0%
 
2 23 1.1%
 
3 17 0.9%
 
4 11 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
233 1 0.1%
 
40 1 0.1%
 
25 2 0.1%
 
24 1 0.1%
 
14 1 0.1%
 

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation0.9999961944

qt_filiais
Numeric

Distinct count42
Unique (%)2.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.996
Minimum0
Maximum9270
Zeros (%)90.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum9270
Range9270
Interquartile range0

Descriptive statistics

Standard deviation284.4729995
Coef of variation20.32530719
Kurtosis830.7848278
Mean13.996
MAD27.18814
Skewness27.83323791
Sum27992
Variance80924.88743
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=42)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 4.500e+00 9.500e+00 6.200e+01 4.665e+02 9.270e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1818 90.9%
 
1 87 4.3%
 
2 26 1.3%
 
3 12 0.6%
 
4 8 0.4%
 
5 3 0.1%
 
8 3 0.1%
 
9 3 0.1%
 
59 2 0.1%
 
7 2 0.1%
 
Other values (32) 36 1.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1818 90.9%
 
1 87 4.3%
 
2 26 1.3%
 
3 12 0.6%
 
4 8 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
9270 1 0.1%
 
7687 1 0.1%
 
2537 1 0.1%
 
2186 1 0.1%
 
1715 1 0.1%
 

qt_funcionarios
Highly correlated

This variable is highly correlated with idade_de_44_a_48 and should be ignored for analysis

Correlation0.9521282594

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.9870025118

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.9812462049

qt_funcionarios_coligados
Highly correlated

This variable is highly correlated with qt_coligados_sudeste and should be ignored for analysis

Correlation0.9073230395

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.9739337033

qt_funcionarios_grupo
Highly correlated

This variable is highly correlated with qt_filiais and should be ignored for analysis

Correlation0.9003805679

qt_ramos_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.9442422997

qt_regioes_coligados
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
1
 
232
2
 
22
4
 
5
(Missing)
1737
ValueCountFrequency (%) 
1 232 11.6%
 
2 22 1.1%
 
4 5 0.2%
 
3 4 0.2%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios
Numeric

Distinct count14
Unique (%)0.7%
Missing (%)25.1%
Missing (n)502
Infinite (%)0.0%
Infinite (n)0
Mean1.394526035
Minimum1
Maximum37
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile2.15
Maximum37
Range36
Interquartile range1

Descriptive statistics

Standard deviation1.349889308
Coef of variation0.9679914714
Kurtosis350.9905593
Mean1.394526035
MAD0.5883652614
Skewness15.30130766
Sum2089
Variance1.822201145
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%) 
1 1117 55.9%
 
2 306 15.3%
 
3 42 2.1%
 
4 12 0.6%
 
5 8 0.4%
 
6 4 0.2%
 
9 2 0.1%
 
8 2 0.1%
 
19 1 0.1%
 
11 1 0.1%
 
Other values (3) 3 0.1%
 
(Missing) 502 25.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1117 55.9%
 
2 306 15.3%
 
3 42 2.1%
 
4 12 0.6%
 
5 8 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
37 1 0.1%
 
19 1 0.1%
 
14 1 0.1%
 
11 1 0.1%
 
9 2 0.1%
 

qt_socios_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation0.9113228208

qt_socios_feminino
Numeric

Distinct count6
Unique (%)0.3%
Missing (%)68.8%
Missing (n)1377
Infinite (%)0.0%
Infinite (n)0
Mean1.109149278
Minimum1
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum11
Range10
Interquartile range0

Descriptive statistics

Standard deviation0.5328106767
Coef of variation0.4803777881
Kurtosis196.6841777
Mean1.109149278
MAD0.2011290061
Skewness11.74412016
Sum691
Variance0.2838872172
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
1 574 28.7%
 
2 40 2.0%
 
3 7 0.4%
 
5 1 0.1%
 
11 1 0.1%
 
(Missing) 1377 68.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 574 28.7%
 
2 40 2.0%
 
3 7 0.4%
 
5 1 0.1%
 
11 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 0.1%
 
5 1 0.1%
 
3 7 0.4%
 
2 40 2.0%
 
1 574 28.7%
 

qt_socios_masculino
Numeric

Distinct count9
Unique (%)0.4%
Missing (%)57.0%
Missing (n)1139
Infinite (%)0.0%
Infinite (n)0
Mean1.221835075
Minimum1
Maximum32
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum32
Range31
Interquartile range0

Descriptive statistics

Standard deviation1.208799857
Coef of variation0.9893314417
Kurtosis491.4704133
Mean1.221835075
MAD0.3849263679
Skewness19.84665356
Sum1052
Variance1.461197094
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
1 747 37.4%
 
2 89 4.5%
 
3 12 0.6%
 
4 6 0.3%
 
5 3 0.1%
 
6 2 0.1%
 
8 1 0.1%
 
32 1 0.1%
 
(Missing) 1139 57.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 747 37.4%
 
2 89 4.5%
 
3 12 0.6%
 
4 6 0.3%
 
5 3 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
32 1 0.1%
 
8 1 0.1%
 
6 2 0.1%
 
5 3 0.1%
 
4 6 0.3%
 

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation0.9867818247

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.9309382851

qt_socios_pj
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)25.1%
Missing (n)502
0
1479
1
 
12
2
 
6
(Missing)
502
ValueCountFrequency (%) 
0 1479 74.0%
 
1 12 0.6%
 
2 6 0.3%
 
3 1 0.1%
 
(Missing) 502 25.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation1

qt_socios_pj_baixados
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)99.1%
Missing (n)1981
0
 
19
(Missing)
1981
ValueCountFrequency (%) 
0 19 0.9%
 
(Missing) 1981 99.1%
 

qt_socios_pj_inaptos
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)99.1%
Missing (n)1981
0
 
19
(Missing)
1981
ValueCountFrequency (%) 
0 19 0.9%
 
(Missing) 1981 99.1%
 

qt_socios_pj_nulos
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)99.1%
Missing (n)1981
0
 
19
(Missing)
1981
ValueCountFrequency (%) 
0 19 0.9%
 
(Missing) 1981 99.1%
 

qt_socios_pj_suspensos
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)99.1%
Missing (n)1981
0
 
19
(Missing)
1981
ValueCountFrequency (%) 
0 19 0.9%
 
(Missing) 1981 99.1%
 

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation0.9649092969

qt_socios_st_suspensa
Categorical

Distinct count3
Unique (%)0.1%
Missing (%)99.3%
Missing (n)1986
1
 
13
2
 
1
(Missing)
1986
ValueCountFrequency (%) 
1 13 0.7%
 
2 1 0.1%
 
(Missing) 1986 99.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_ufs_coligados
Numeric

Distinct count9
Unique (%)0.4%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean1.338403042
Minimum1
Maximum8
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile3
Maximum8
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.9707204558
Coef of variation0.7252826133
Kurtosis17.29454941
Mean1.338403042
MAD0.5610027614
Skewness3.894238964
Sum352
Variance0.9422982033
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
1 218 10.9%
 
2 27 1.4%
 
3 6 0.3%
 
5 5 0.2%
 
4 4 0.2%
 
6 1 0.1%
 
7 1 0.1%
 
8 1 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 218 10.9%
 
2 27 1.4%
 
3 6 0.3%
 
4 4 0.2%
 
5 5 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 0.1%
 
7 1 0.1%
 
6 1 0.1%
 
5 5 0.2%
 
4 4 0.2%
 

setor
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.5%
Missing (n)11
COMERCIO
927
SERVIÇO
792
INDUSTRIA
 
134
Other values (2)
 
136
ValueCountFrequency (%) 
COMERCIO 927 46.4%
 
SERVIÇO 792 39.6%
 
INDUSTRIA 134 6.7%
 
CONSTRUÇÃO CIVIL 122 6.1%
 
AGROPECUARIA 14 0.7%
 
(Missing) 11 0.5%
 
Max length16
Mean length8.1595
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sg_uf
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
MA
534
RN
415
AM
353
Other values (3)
698
ValueCountFrequency (%) 
MA 534 26.7%
 
RN 415 20.8%
 
AM 353 17.6%
 
PI 328 16.4%
 
RO 266 13.3%
 
AC 104 5.2%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count18
Unique (%)0.9%
Missing (%)0.5%
Missing (n)11
MA
523
RN
410
AM
347
Other values (14)
709
ValueCountFrequency (%) 
MA 523 26.2%
 
RN 410 20.5%
 
AM 347 17.3%
 
PI 320 16.0%
 
RO 259 13.0%
 
AC 99 5.0%
 
DF 7 0.4%
 
SP 5 0.2%
 
RJ 4 0.2%
 
CE 3 0.1%
 
Other values (7) 12 0.6%
 
(Missing) 11 0.5%
 
Max length3
Mean length2.0055
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.9984290135

total
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation0.9914053461

total_filiais_coligados
Highly correlated

This variable is highly correlated with qt_socios_coligados and should be ignored for analysis

Correlation0.9651560413

tx_crescimento_12meses
Numeric

Distinct count69
Unique (%)3.5%
Missing (%)82.9%
Missing (n)1658
Infinite (%)0.0%
Infinite (n)0
Mean-3.746989236
Minimum-100
Maximum216.6666667
Zeros (%)10.5%
Mini histogram

Quantile statistics

Minimum-100
5-th percentile-50
Q10
Median0
Q30
95-th percentile35.98571429
Maximum216.6666667
Range316.6666667
Interquartile range0

Descriptive statistics

Standard deviation31.37130232
Coef of variation-8.372402571
Kurtosis10.55088936
Mean-3.746989236
MAD16.56969509
Skewness0.5035561138
Sum-1281.470319
Variance984.1586091
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 210 10.5%
 
-100 12 0.6%
 
-33.33333333 10 0.5%
 
-50 9 0.4%
 
50 8 0.4%
 
-25 7 0.4%
 
-14.28571429 5 0.2%
 
25 5 0.2%
 
100 3 0.1%
 
33.33333333 3 0.1%
 
Other values (58) 70 3.5%
 
(Missing) 1658 82.9%
 

Minimum 5 values

ValueCountFrequency (%) 
-100 12 0.6%
 
-93.82716049 1 0.1%
 
-83.33333333 1 0.1%
 
-62.5 1 0.1%
 
-60 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
216.6666667 1 0.1%
 
128.5714286 1 0.1%
 
100 3 0.1%
 
84.21052632 1 0.1%
 
57.14285714 1 0.1%
 

tx_crescimento_24meses
Numeric

Distinct count95
Unique (%)4.8%
Missing (%)82.3%
Missing (n)1646
Infinite (%)0.0%
Infinite (n)0
Mean-13.95242578
Minimum-100
Maximum600
Zeros (%)6.6%
Mini histogram

Quantile statistics

Minimum-100
5-th percentile-100
Q1-42.26190476
Median0
Q30
95-th percentile68.68852459
Maximum600
Range700
Interquartile range42.26190476

Descriptive statistics

Standard deviation64.88506624
Coef of variation-4.650450557
Kurtosis28.54370355
Mean-13.95242578
MAD37.59206522
Skewness3.769340498
Sum-4939.158727
Variance4210.071821
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 131 6.6%
 
-100 39 1.9%
 
-50 17 0.9%
 
-25 12 0.6%
 
-33.33333333 11 0.5%
 
100 8 0.4%
 
-20 8 0.4%
 
-66.66666667 7 0.4%
 
-40 6 0.3%
 
200 4 0.2%
 
Other values (84) 111 5.5%
 
(Missing) 1646 82.3%
 

Minimum 5 values

ValueCountFrequency (%) 
-100 39 1.9%
 
-94.73684211 1 0.1%
 
-90.90909091 1 0.1%
 
-87.5 1 0.1%
 
-85.71428571 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
600 1 0.1%
 
400 1 0.1%
 
300 1 0.1%
 
200 4 0.2%
 
125 1 0.1%
 

tx_rotatividade
Numeric

Distinct count69
Unique (%)3.5%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean8.127274797
Minimum0
Maximum200
Zeros (%)18.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile40
Maximum200
Range200
Interquartile range0

Descriptive statistics

Standard deviation22.02773902
Coef of variation2.710347512
Kurtosis29.0538715
Mean8.127274797
MAD12.69423094
Skewness4.662630838
Sum3795.43733
Variance485.2212865
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 362 18.1%
 
33.33333333 9 0.4%
 
28.57142857 8 0.4%
 
40 7 0.4%
 
25 4 0.2%
 
15.38461538 2 0.1%
 
16.66666667 2 0.1%
 
23.52941176 2 0.1%
 
11.76470588 2 0.1%
 
90.90909091 2 0.1%
 
Other values (58) 67 3.4%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 362 18.1%
 
2.941176471 1 0.1%
 
4 1 0.1%
 
4.651162791 1 0.1%
 
5 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
200 1 0.1%
 
190.9836066 1 0.1%
 
150 1 0.1%
 
133.3333333 1 0.1%
 
90.90909091 2 0.1%
 

vl_faturamento_estimado_aux
Highly correlated

This variable is highly correlated with total and should be ignored for analysis

Correlation0.9849750322

vl_faturamento_estimado_grupo_aux
Highly correlated

This variable is highly correlated with qt_socios_st_suspensa and should be ignored for analysis

Correlation0.9487115171

vl_folha_coligados
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.9470885171

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with vl_folha_coligados and should be ignored for analysis

Correlation0.9239805026

vl_frota
Numeric

Distinct count112
Unique (%)5.6%
Missing (%)94.2%
Missing (n)1885
Infinite (%)0.0%
Infinite (n)0
Mean101608.5478
Minimum1680
Maximum783042
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1680
5-th percentile4225.6
Q129530
Median57476
Q3106890
95-th percentile354267.6
Maximum783042
Range781362
Interquartile range77360

Descriptive statistics

Standard deviation134085.1766
Coef of variation1.319624967
Kurtosis9.34406756
Mean101608.5478
MAD86045.55599
Skewness2.870761613
Sum11684983
Variance1.797883459e+10
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
72838 2 0.1%
 
98819 2 0.1%
 
39289 2 0.1%
 
41298 2 0.1%
 
76140 1 0.1%
 
8069 1 0.1%
 
169124 1 0.1%
 
241833 1 0.1%
 
71556 1 0.1%
 
783042 1 0.1%
 
Other values (101) 101 5.1%
 
(Missing) 1885 94.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1680 1 0.1%
 
2429 1 0.1%
 
3306 1 0.1%
 
3375 1 0.1%
 
3392 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
783042 1 0.1%
 
656552 1 0.1%
 
561218 1 0.1%
 
537698 1 0.1%
 
481226 1 0.1%
 

vl_idade_maxima_socios_pj
Numeric

Distinct count19
Unique (%)0.9%
Missing (%)99.1%
Missing (n)1981
Infinite (%)0.0%
Infinite (n)0
Mean10.94362189
Minimum1.314168378
Maximum30.06433949
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.314168378
5-th percentile3.987679671
Q16.977412731
Median9.87816564
Q312.55715264
95-th percentile24.01013005
Maximum30.06433949
Range28.75017112
Interquartile range5.579739904

Descriptive statistics

Standard deviation6.800181946
Coef of variation0.621383123
Kurtosis2.679513486
Mean10.94362189
MAD4.756913358
Skewness1.463400182
Sum207.9288159
Variance46.2424745
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%) 
9.87816564 2 0.1%
 
23.33744011 1 0.1%
 
6.119096509 1 0.1%
 
15.34291581 1 0.1%
 
4.594113621 1 0.1%
 
30.06433949 1 0.1%
 
13.3744011 1 0.1%
 
5.837097878 1 0.1%
 
8.884325804 1 0.1%
 
8.265571526 1 0.1%
 
Other values (8) 8 0.4%
 
(Missing) 1981 99.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1.314168378 1 0.1%
 
4.284736482 1 0.1%
 
4.594113621 1 0.1%
 
5.837097878 1 0.1%
 
6.119096509 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
30.06433949 1 0.1%
 
23.33744011 1 0.1%
 
16.57494867 1 0.1%
 
15.34291581 1 0.1%
 
13.3744011 1 0.1%
 

vl_idade_media_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis

Correlation0.9804465153

vl_idade_minima_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis

Correlation0.9810183741

vl_potenc_cons_oleo_gas
Highly correlated

This variable is highly correlated with vl_folha_coligados_gp and should be ignored for analysis

Correlation0.9999548647

vl_total_tancagem
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_tancagem_grupo
Highly correlated

This variable is highly correlated with vl_folha_coligados_gp and should be ignored for analysis

Correlation1

vl_total_veiculos_antt
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_antt_grupo
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_leves
Numeric

Distinct count13
Unique (%)0.7%
Missing (%)93.2%
Missing (n)1864
Infinite (%)0.0%
Infinite (n)0
Mean1.610294118
Minimum0
Maximum24
Zeros (%)1.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median1
Q32
95-th percentile5
Maximum24
Range24
Interquartile range1

Descriptive statistics

Standard deviation2.602485405
Coef of variation1.61615532
Kurtosis41.78943292
Mean1.610294118
MAD1.350129758
Skewness5.544720745
Sum219
Variance6.772930283
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%) 
1 66 3.3%
 
0 32 1.6%
 
2 18 0.9%
 
3 7 0.4%
 
4 4 0.2%
 
5 3 0.1%
 
11 1 0.1%
 
8 1 0.1%
 
24 1 0.1%
 
9 1 0.1%
 
Other values (2) 2 0.1%
 
(Missing) 1864 93.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 32 1.6%
 
1 66 3.3%
 
2 18 0.9%
 
3 7 0.4%
 
4 4 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
24 1 0.1%
 
11 1 0.1%
 
9 1 0.1%
 
8 1 0.1%
 
7 1 0.1%
 

vl_total_veiculos_leves_grupo
Numeric

Distinct count35
Unique (%)1.8%
Missing (%)0.5%
Missing (n)11
Infinite (%)0.0%
Infinite (n)0
Mean21.32679739
Minimum0
Maximum35064
Zeros (%)91.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum35064
Range35064
Interquartile range0

Descriptive statistics

Standard deviation788.3362551
Coef of variation36.96458689
Kurtosis1966.891524
Mean21.32679739
MAD41.80239684
Skewness44.23709965
Sum42419
Variance621474.0511
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%) 
0 1834 91.7%
 
1 71 3.5%
 
2 26 1.3%
 
3 9 0.4%
 
4 7 0.4%
 
8 5 0.2%
 
5 4 0.2%
 
88 2 0.1%
 
6 2 0.1%
 
18 2 0.1%
 
Other values (24) 27 1.4%
 
(Missing) 11 0.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1834 91.7%
 
1 71 3.5%
 
2 26 1.3%
 
3 9 0.4%
 
4 7 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
35064 1 0.1%
 
2134 1 0.1%
 
888 1 0.1%
 
782 1 0.1%
 
479 1 0.1%
 

vl_total_veiculos_pesados
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.9118619239

vl_total_veiculos_pesados_grupo
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.909344757

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0536.366667NaN57.3NaNDE R$ 1.500.000,01 A R$ 4.800.000,00DE R$ 1.500.000,01 A R$ 4.800.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTAINDUSTRIA DA CONSTRUCAOACIMA DE 1 ANOVERDE2005-03-25NaN21809443.022019443.0FalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN1.025.0NaNa6984c3ae395090e3bee8ad63c3758b110de096d5d8195...1.0NaN1.04.06.05.03.04.02.0NaN10 a 1514.457534536.36666747.0220.477778220.477778NaN44.057.341.013188096.013188096.01.091.093.26666793.2666675275238.55275238.53.634907e+063.669907e+061.00000036.2543.73846213.3091952343978.02343978.019.166667210000.0210000.01.06.019.166667-0.933333638798.4638798.4ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSLESTE POTIGUARNATALCONSTRUCAO23.00.0100.0145.00.0NaNNaNNaNNaN8.06.06.00.00.00.00.00.00.06.00.00.00.01.00.00.00.00.00.06.00.00.06.00.00.00.05.00.00.00.0119.00.0119.0026.026.027.0145.0145.026.05.01.02.08.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN2.0CONSTRUÇÃO CIVILRNRN21809443.026.01.00.0-3.7037040.03132172.83132172.89375912.09375912.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXASERVICOS DE ALOJAMENTO/ALIMENTACAOATE 1 ANOCINZA2017-05-12468.93NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.463014NaN27.0NaNNaNNaN27.0NaN27.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSALIMENTACAOCENTRO NORTE PIAUIENSETERESINAALOJAMENTO E ALIMENTACAO9.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
2NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-09-26713.50NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 107.093151NaN32.0NaNNaNNaN32.0NaN32.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSTRANSPORTE TERRESTRECENTRO AMAZONENSEMANAUSTRANSPORTE ARMAZENAGEM E CORREIO26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaNNaN1.0NaNSERVIÇOAMAMNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
3NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIASERVICOS DIVERSOSACIMA DE 1 ANOAMARELO2012-04-25475.73NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN3348900fe63216a439d2e5238c79ddd46ede454df7b9d8...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 106.512329NaN36.0NaNNaNNaN36.0NaN36.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSREPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO...CENTRO AMAZONENSEMANAUSOUTRAS ATIVIDADES DE SERVICOS26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
4NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2015-08-172874.04NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 53.200000NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...LESTE POTIGUARNATALATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS27.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
5NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTAQUIMICA-PETROQUIMICAACIMA DE 1 ANOLARANJA2005-11-03NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb6...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2038.079452NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOSOESTE POTIGUARPAU DOS FERROSINDUSTRIAS DE TRANSFORMACAO48.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNINDUSTRIARNRNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
6NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-07-21NaNNaNNaNFalseTrueFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN8bf37c178778e537b108e58bf20552abe10c3a7fae129b...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 107.276712NaN63.0NaNNaNNaN63.0NaN63.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSTRANSPORTE TERRESTRENORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISTRANSPORTE ARMAZENAGEM E CORREIO23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOMAMANaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
7NaNNaNNaNNaNNaNNaNNaNEMPRESARIO INDIVIDUALALTASERVICOS ADMINISTRATIVOSNaNNaN2018-10-09NaNNaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN0114fd3fbdc347c561843cde6aece12e8e53cb5d32c77d...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.052055NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSAGENCIAS DE VIAGENS OPERADORES TURISTICOS E SE...LESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇORNRNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
8NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00BOACOOPERATIVAALTABENS DE CONSUMOACIMA DE 1 ANOAZUL2006-07-27247.88NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN6c45aabb849a760a3a7107c7a61262642f683feb8912a4...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10 a 1512.263014NaN36.0NaNNaNNaN36.0NaN36.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DIVERSOSCENTRO AMAZONENSEPARINTINSINDUSTRIAS DE TRANSFORMACAO24.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN2.0NaNNaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNINDUSTRIAAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
9367.666667NaN176.7NaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERMELHO2004-10-301042.854200000.013440000.0FalseFalseFalseFalseFalseFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN2fcd678d71b04ccb77644fff57706bdc7fcfbbec6b1926...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN15 a 2017.942466367.66666752.0235.478333235.478333NaN52.0176.752.0210000.0840000.03.0NaNNaNNaNNaNNaN2.100000e+056.720000e+052.428571NaNNaNNaNNaNNaNNaN210000.0210000.02.0NaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTAOESTE POTIGUARMOSSOROCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...54.0NaNNaNNaNNaNNaNNaNNaNNaNNaN5.06.00.00.00.00.00.00.020.00.00.00.020.00.00.00.00.00.011.00.00.020.00.00.00.00.00.00.00.0NaNNaNNaN3NaNNaNNaNNaNNaNNaN3.01.01.020.0NaN1.0NaN1.00.0NaNNaNNaNNaNNaNNaNNaN1.0COMERCIORNRN1050000.0NaN17.0NaNNaNNaN210000.0840000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
1990NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNSOCIEDADE EMPRESARIA LIMITADAMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERMELHO2006-12-021733.06NaNNaNFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN55d44caf6853a4e743b307f58f6e419cd3194ddcfdcf49...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2028.542466NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTAOESTE POTIGUARVALE DO ACUCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...22.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN210000.0420000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1991NaNNaNNaNNaNNaNNaNNaNEMPRESARIO INDIVIDUALBAIXASERVICOS DE ALOJAMENTO/ALIMENTACAOSEM INFORMACAOCINZA2018-04-16NaNNaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN47b9cfb6af1ee3a9dbf9f3ab07ac27f9d41fc0379335db...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.534247NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSALIMENTACAONaNNaNALOJAMENTO E ALIMENTACAONaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇORORONaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1992NaNNaNNaNNaNNaNNaNNaNCANDIDATO A CARGO POLITICO ELETIVONaNSERVICOS DIVERSOSNaNNaN2018-08-14NaNNaNNaNFalseTrueFalseFalseTrueFalseFalseNaNNaNTrueSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaNa7cb40a5415cfc1638fd8b51b31c189ef9902070bb6e13...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.205479NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCARGO POLITICOATIVIDADES DE ORGANIZACOES ASSOCIATIVASNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISOUTRAS ATIVIDADES DE SERVICOSNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1993NaNNaNNaNNaNDE R$ 360.000,01 A R$ 1.500.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2011-01-17898.18NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaN2.01.06034e37dc7ac83441836259dc9c02854fce0a6100fded9...1.0NaNNaNNaN2.0NaNNaNNaNNaNNaN5 a 107.783562NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN94.294.2NaNNaNNaNNaNNaNNaN74.62222255.513333NaNNaN39.466667NaNNaNNaNNaN39.46666714.2NaNNaNOUTROSCOMERCIO VAREJISTASUL MARANHENSEPORTO FRANCOCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...22.066.6733.335.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2.00.02.003.03.03.0NaNNaN3.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOMAMANaN3.0NaN0.00.00.0556372.8556372.8NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1994NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIASIDERURGICA-METALURGIAATE 1 ANOCINZA2017-04-30690.18NaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNe3398e8ddd4212305a29d3bc0a7a7381959ca3f2c5fbae...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.495890NaN20.0NaNNaNNaN20.0NaN20.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSFABRICACAO DE PRODUTOS DE METAL EXCETO MAQUINA...CENTRO AMAZONENSEMANAUSINDUSTRIAS DE TRANSFORMACAO9.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNINDUSTRIAAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1995NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00BOAASSOCIACAO PRIVADAALTACULTURA, ESPORTE E RECREACAOACIMA DE 1 ANOVERDE2005-11-033321.86NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN9607a5802e8e4aa7de7890043283082d764290b97cf239...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2037.728767NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES SEM FINS LUCRATIVOSATIVIDADES ESPORTIVAS E DE RECREACAO E LAZERCENTRO NORTE PIAUIENSETERESINAARTES CULTURA ESPORTE E RECREACAO26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1996NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXATRANSPORTE, ARMAZENAGEM E CORREIOSEM INFORMACAOCINZA2018-01-29660.83NaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNb5a8faacbf4ffb9f9e484fc0834f8f7e949de93fba3716...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.745205NaN28.0NaNNaNNaN28.0NaN28.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSTRANSPORTE TERRESTRESUDOESTE PIAUIENSESAO RAIMUNDO NONATOTRANSPORTE ARMAZENAGEM E CORREIONaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1997NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2014-09-02NaNNaNNaNFalseTrueFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN34c74885c6f792ec82587c2b4d93fb4791f8367b8c6e1b...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 54.156164NaN35.0NaNNaNNaN35.0NaN35.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...47.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1998NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALALTASERVICOS DE ALOJAMENTO/ALIMENTACAOACIMA DE 1 ANOVERDE2016-08-173597.12NaNNaNFalseTrueFalseFalseTrueFalseTrueTrueTrueTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN748fa25fe9ab6098ca9fefae265b5df3a57cb7ab27b041...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 52.197260NaN29.0NaNNaNNaN29.0NaN29.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSALIMENTACAOVALE DO ACRERIO BRANCOALOJAMENTO E ALIMENTACAO23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOACACNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1999NaNNaNNaNNaNDE R$ 360.000,01 A R$ 1.500.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO POR ATACADOACIMA DE 1 ANOAZUL2005-11-03765.23NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN02358bfbe4d3297235e3998662e20f9bc1455755719cc3...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN15 a 2017.189041NaN61.0NaNNaNNaN61.0NaN61.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTOR...LESTE POTIGUARNATALCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...22.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN930000.0930000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0